PRINT '-------------------------------------------'
PRINT 'Starting execution of PBDsk_GigyaUser.SQL'
PRINT '-------------------------------------------'
GO

SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON         -- We don't want (NULL = NULL) == TRUE
GO
SET ANSI_PADDING ON
GO
SET ANSI_NULL_DFLT_ON ON
GO




IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'PBDsk_GigyaUser')
                  AND (type = 'U')))
BEGIN
	  CREATE TABLE PBDsk_GigyaUser(
			[GigyaUID] [varchar](256) NOT NULL,
			[LoginProvider] [varchar](256) NOT NULL,
			[LoginProviderUID] [varchar] (256) NOT NULL,
			[NickName] [varchar] (256) NULL,
			[Email] [varchar] (512) NULL,
			[FName] [varchar](200) NULL,
			[LName] [varchar](200) NULL,
			[Gender] [varchar](1) NULL,
			[DateOfBirth] [smalldatetime] NULL,
			[City] [varchar](200) NULL,
			[State] [varchar](200) NULL,
			[Country] [varchar](200) NULL,
			[ZIP] [varchar](12) NULL,
			[PhotoUrl] [varchar] (1024) NULL,
			[ThumbnailUrl] [varchar] (1024) NULL,
			[ProfileUrl] [varchar] (1024) NULL,
			[StartDate] [smalldatetime] NULL,
			[LastUpdDt] [smalldatetime] NULL,
			[IsActive] [bit] NULL
		 CONSTRAINT [PK_PBDsk_GigyaUser] PRIMARY KEY CLUSTERED 
		(
			[GigyaUID] ASC
		)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
		) ON [PRIMARY]
END
GO



PRINT '--------------------------------------------'
PRINT 'Completed execution of PBDsk_GigyaUser.SQL'
PRINT '--------------------------------------------'

